This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
RE: Need some TIPs: Managing Databases with many Documents ~Mario Lopkistergon 27.Jan.04 08:18 PM a Web browser General All ReleasesAll Platforms
Well data is data. I guess the more pivotal topic is what is the database doing? Meaning do you have a lot of computed column values in the views? Do you have many @dblookups on views based on a key? What is the database growth? How often are the document modified.
I had a client whose had data in a lotus notes database. There were over 1.3 million documents in the database and I was able to get all the documents quickly. What I did was to create a search engine functionality to search the database via full text searching.
But there are many ways to attack large databases.